简单的数据库管理系统(源码+数据库脚本)

通过页面对于数据库数据进行，增改查，是一个比较初级的代码，适合刚入门的人学习研究

package mysystem;

import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.SwingConstants;

import dialog.addDialog;
import dialog.deleteDialog;
import dialog.queryDialog;
import dialog.updateDialog;

public class frame extends JFrame implements ActionListener {

    JMenuBar menubar = new JMenuBar();

    JMenu studentMenu = new JMenu("信息");
    //JMenu studentMenu1 = new JMenu("成绩");
    JMenuItem additem = new JMenuItem("学生录入");
    //JMenuItem additem1 = new JMenuItem("学生成绩录入");
    JMenuItem updateitem = new JMenuItem("学生修改");
    //JMenuItem updateitem1 = new JMenuItem("学生成绩修改");
    JMenuItem queryitem = new JMenuItem("学生查询");
    //JMenuItem queryitem1 = new JMenuItem("学生成绩查询");
    JMenuItem deleteitem = new JMenuItem("学生删除");
   // JMenuItem deleteitem1 = new JMenuItem("学生成绩删除");
    JLabel label = new JLabel("学生学籍管理系统");
    addDialog add = null;
    updateDialog update = null;
    queryDialog query = null;
    deleteDialog delete = null;

    public frame() {
        this.setTitle("学生学籍管理系统");
        this.setJMenuBar(menubar);
        menubar.add(studentMenu);
        //menubar.add(studentMenu1);
        studentMenu.add(additem);
        //studentMenu1.add(additem);
        studentMenu.add(updateitem);
        //studentMenu1.add(updateitem);
        studentMenu.add(queryitem);
        //studentMenu1.add(queryitem);
        studentMenu.add(deleteitem);
        //studentMenu1.add(deleteitem);
        additem.addActionListener(this);
        updateitem.addActionListener(this);
        queryitem.addActionListener(this);
        deleteitem.addActionListener(this);
        label.setFont(new java.awt.Font("DialogInput", 1, 48));
        label.setHorizontalAlignment(SwingConstants.CENTER);
        label.setForeground(Color.pink);
        this.getContentPane().add(label);
        this.setSize(600, 400);
        this.setLocationRelativeTo(null);
        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        this.setVisible(true);

    }

    /**
     *
     */
    private static final long serialVersionUID = 1L;

    @Override
    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == additem) {
            add = new addDialog(this);
        } else if (e.getSource() == updateitem) {
            update = new updateDialog(this);
        } else if (e.getSource() == queryitem) {
            query = new queryDialog(this);
        } else if (e.getSource() == deleteitem) {
            delete = new deleteDialog(this);
        }

    }

}

public class shujuku {
private static Connection cnt = null;
private static PreparedStatement pre = null;
private static ResultSet rst = null;
private static String dbDriver = "com.mysql.jdbc.Driver";
private static String dbURL = "jdbc:mysql://localhost:3306/mysystem?serverTimezone=GMT%2B8&useSSL=false";
private static String dbId = "root";
private static String dbPsw = "11171010";
public static int countrow = 0;
private static String[] RstColumn = new String[10];
private static ResultSetMetaData rsmd;

// �������ݿ�����,�������ݿ�
public static Connection getConnection() {
try {
Class.forName(dbDriver);
cnt = DriverManager.getConnection(dbURL, dbId, dbPsw);
} catch (Exception e) {
System.out.println("数据库连接异常");
e.printStackTrace();

}
return cnt;

}

public static void dBClose() {

if (cnt != null) {
try {
cnt.close();
} catch (Exception e) {
e.printStackTrace();
System.out.println("cnt关闭出现异常");
}
}
if (pre != null) {
try {
pre.close();
} catch (Exception e) {
e.printStackTrace();
System.out.println("pre关闭异常");
}
}
if (rst != null) {
try {
rst.close();
} catch (Exception e) {
e.printStackTrace();
System.out.println("rst关闭异常");
}
}
}

}